Weekly Report for Hospital Data¶

This is a weekly report about the hospital beds in the USA. We will use tables and plots to analyze the data.

1.1 Summary of Loaded Records¶

In this table, we list the recent five weeks hospital data upload date and rows loaded. On Oct 21, 2022, the total number of rows loaded is 4985. We can see for the past four weeks, the total number of records loaded are all around 5000.


1.2 Summary of Hospital Beds¶

In this table, we list the recent five weeks hospital beds situation. It includes the upload date, load rows number, how many adult/pediatric beds are available or in-use, total hospital beds used by Covid cases. There are around two thousand more adult beds available and in-use compared with the last week, hospitals may have 4000 new beds since last week.


1.3 Fraction of Beds Currently in use by Hospital Quality Rating¶

This table includes hospital’s rating, percentage of beds in use compared with the total number of beds of that hospital. For those hospitals have highest rating, 66% adult and pediatric beds are in-use, 67% ICU beds are in-use.


1.4 Number of Beds in use of all cases and covid cases¶

This bar plot shows the total number of hospital beds used per week for all causes and covid cases in the recent five weeks. On Oct 21, 2022, 2626 more beds were in use for all cases, and there are 421 beds occupied by patients have Covid.

These pie charts show the percentage of hospital beds used per week for all causes and covid cases. We can see in the recent five weeks, the percentage didn’t change too much, all cases have around 95% of beds in-use and 5% beds in-use for Covid cases.


2.1 The number of COVID cases by state¶

This map shows how many Covid cases we have in the USA until Oct 21, 2022. Darker the color, this state has more people have Covid. In New York state, there are 1841 people have Covid.


2.2 State COVID cases changes¶

This table listed the top 5 states with the most Covid cases changes status. We didn’t get data from Guam and the Virgin Islands either this week or last week. Illinois has 133 more Covid cases compared with last week.


2.3 Hospitals with largest changes in COVID cases¶

In this table, we list the top five hospitals with the largest changes in Covid cases, with their information. Carolinas Medical center has the largest changes. What interesting is that it’s located in North Carolina, where doesn’t have lots of Covid cases changes.


2.4 Hospital with no reported data¶

It’s a table of hospital names which did not report data last week, with the last reported date. There are 17 hospitals doesn’t have data this week (2022-10-21).